package com.itheima.mapper;


import com.itheima.pojo.Emp;
import org.apache.ibatis.annotations.*;

import java.time.LocalDate;
import java.util.List;


@Mapper
public interface EmpMapper {
    @Select("select count(*) from web01.emp e left join web01.dept d on d.id = e.dept_id")
    public long count();
//    @Select("select e.* ,d.name from  web01.emp e left join  web01.dept d on e.dept_id = d.id where e.name like '%张%' and e.gender = #{gender} and e.entry_date between #{begin} and #{end} order by e.update_time desc  limit #{start},#{pageSize}")
    public List<Emp> list(@Param("start") Integer start, @Param("pageSize") Integer pageSize, String name, Integer gender, LocalDate begin, LocalDate end);

}
